<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="en">
<head>
    <title>MydbQA - Analyze report</title>
    <link href="style/main.css" rel="stylesheet" type="text/css" />
    <link href="style/highlight/styles/default.css" rel="stylesheet" type="text/css" />
    <TMPL_UNLESS nohighlight>
        <script type="text/javascript" src="style/highlight/highlight.js"></script>
        <script type="text/javascript">initHighlightingOnLoad();</script>
    </TMPL_UNLESS>
</head>
<body>
    <br />
    <div id="extract">
        <h1>Columns data</h1><br />
        <TMPL_LOOP columns>
            <div class="box mt10">
                <p>Column: <b><TMPL_VAR database>.<TMPL_VAR table>.<TMPL_VAR column></b></p>
                <table>
                    <tr class="header">
                        <td>NUMERIC_PRECISION</td>
                        <td>COLUMN_DEFAULT</td>
                        <td>TOTAL_COUNT</td>
                        <td>COLUMN_KEY</td>
                        <td>CHARACTER_SET_NAME</td>
                        <td>IS_DISTINCT</td>
                        <td>COLUMN_TYPE</td>
                        <td>PREFIX_SELECTIVITY</td>
                        <td>COLLATION_NAME</td>
                        <td>IS_NULLABLE</td>
                        <td>ORDINAL_POSITION</td>
                        <td>CHARACTER_OCTET_LENGTH</td>
                        <td>COLUMN_NAME</td>
                        <td>CHARACTER_MAXIMUM_LENGTH</td>
                        <td>NUMERIC_SCALE</td>
                        <td>DATA_TYPE</td>
                        <td>TABLE_NAME</td>
                        <td>TABLE_SCHEMA</td>
                        <td>PRIVILEGES</td>
                        <td>EXTRA</td>
                        <td>COLUMN_COMMENT</td>
                        <td>TABLE_CATALOG</td>
                    </tr>
                    <tr>
                        <td><TMPL_VAR NUMERIC_PRECISION></td>
                        <td><TMPL_VAR COLUMN_DEFAULT></td>
                        <td><TMPL_VAR TOTAL_COUNT></td>
                        <td><TMPL_VAR COLUMN_KEY></td>
                        <td><TMPL_VAR CHARACTER_SET_NAME></td>
                        <td><TMPL_VAR IS_DISTINCT></td>
                        <td><TMPL_VAR COLUMN_TYPE></td>
                        <td><TMPL_VAR PREFIX_SELECTIVITY></td>
                        <td><TMPL_VAR COLLATION_NAME></td>
                        <td><TMPL_VAR IS_NULLABLE></td>
                        <td><TMPL_VAR ORDINAL_POSITION></td>
                        <td><TMPL_VAR CHARACTER_OCTET_LENGTH></td>
                        <td><TMPL_VAR COLUMN_NAME></td>
                        <td><TMPL_VAR CHARACTER_MAXIMUM_LENGTH></td>
                        <td><TMPL_VAR NUMERIC_SCALE></td>
                        <td><TMPL_VAR DATA_TYPE></td>
                        <td><TMPL_VAR TABLE_NAME></td>
                        <td><TMPL_VAR TABLE_SCHEMA></td>
                        <td><TMPL_VAR PRIVILEGES></td>
                        <td><TMPL_VAR EXTRA></td>
                        <td><TMPL_VAR COLUMN_COMMENT></td>
                        <td><TMPL_VAR TABLE_CATALOG></td>
                    </tr>
                    
                </table>
            </div>
        </TMPL_LOOP>
    </div>
    <br /><br/>
</body>
</html>